query= 

			-- _c_empresa.php inicializar()
			SELECT *
			FROM empresa
			WHERE 1=1
			  AND web 			= 100
			
			AND estado = 'A'
		

num_tuplas= 
95

query= 
-- _c_zonas.php / cargar_metazonas_superzonas_zonas()
			SELECT
				 metazonas.cod_metazona
				 -- 20131122 avv
				,metazonas.cod_provincia
				,metazonas.denom_metazona
				,superzonas.cod_superzona
				,superzonas.denom_superzona

				-- 20131129 rbz [1872-1873]
				,metazonas.coord_latitud
				,metazonas.coord_longitud
				,metazonas.area_coordenadas
				,metazonas.zoom_mapa

			FROM
				 metazonas
				,superzonas

			WHERE
				-- 20130902 rbz [1826-1827]
				--  superzonas.web				= '100'
				  superzonas.web				= 0
			  AND metazonas.cod_metazona		= superzonas.cod_metazona
			  AND superzonas.cod_metazona		IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61   ,99)

				-- 20140116 rbz [20140116a].
				

				-- [20180426b]
				

			ORDER BY
				 metazonas.cod_metazona
				,superzonas.cod_superzona
			;
		

num_tuplas= 
9229

query= 
-- _c_zonas.php cargar_zonas()
			SELECT
				 zonas.cod_metazona
				,zonas.cod_superzona
				,zonas.cod_maxizona
				,zonas.cod_zona
				,zonas.denom_zona
			FROM
				 zonas
			WHERE
				-- 20130902 rbz [1826-1827]
				-- web						= '100'
				  web						= 0

			  AND zonas.cod_metazona      IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61   ,99)
			-- //20130425a rbz [20130425a] Cuidado! Esto podrá mejorar el rendimiento, pero al acceder al detalle de propiedad, el formulario de búsqueda avanzado queda incompleto! (le faltan todas las zonas menos la de la propiedad consultada
			--  AND (zonas.cod_superzona		= '' OR '' = '')
			  AND zonas.indicador            > 0

			-- 20140116 rbz [20140116a]..
			

			-- [20180426b]
			

			ORDER BY
				 zonas.cod_superzona
				,zonas.cod_zona
			;
		

num_tuplas= 
15733

query= 
-- _c_zonas.php cargar_subzonas()
			SELECT
				 subzonas.cod_metazona
				,subzonas.cod_superzona
				,subzonas.cod_zona
				,subzonas.cod_subzona
				,subzonas.denom_subzona
			FROM
				 subzonas
			WHERE
				  web						= 0
			  AND subzonas.cod_metazona      IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61   ,99)

				-- 20140116 rbz [20140116a]....
				

				-- [20180426b]
				


			ORDER BY
				 subzonas.cod_metazona
				,subzonas.cod_superzona
				,subzonas.cod_zona
			;
		

num_tuplas= 
977

España. Property search.
Cargando...

Property search

query= 
-- _f_propiedades.php listar_propiedades()
			SELECT
			*
			FROM propiedad
			WHERE
		
		 web = 100 -- std
		

 -- cond_empresa 


 AND cod_empresa != 0  -- p.
		
		AND (
				-- propiedades de empresas no excluidas de MLS
				(
					(web, cod_empresa) NOT IN (
						SELECT web_cap, cod_empresa_cap
						FROM empresa_config_mls
						WHERE web = 100
							AND cod_empresa = 0
							AND cod_propiedad IS NULL
							AND estado = 'C'
					)
				)
				AND
				-- propiedades no excluidas de MLS
				(
					cod_propiedad NOT IN (
						SELECT cod_propiedad
						FROM empresa_config_mls
						WHERE web = 100
							AND cod_empresa = 0
							AND cod_propiedad IS NOT NULL
							AND estado = 'C'
					)
				)
				AND
				-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
				(
					cod_propiedad NOT IN (
						SELECT cod_propiedad
						FROM empresa_config_mls
						WHERE estado = 'X'
					)
				)
			)
		
		-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
		 -- nop!
		AND propiedad.cod_oficina			= 0

		AND ( cod_empresa != 1 OR  1=2  )		-- ceidemo 1 && 

		

		AND propiedad.cod_propiedad NOT IN (0)

		

		

		
		AND (
				( propiedad.estado			IN ('A','O','B') )
			||	( propiedad.estado			IN ('V','R') AND fecha_ult_mod > '20240502' AND NOT  1=2 )		-- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
			||	( propiedad.estado			= 'V' AND 0 =1 )
			||	( propiedad.estado			= 'R' AND 0 =1 )
			||	( propiedad.estado			= '3' AND 0 =1 )
			||	( propiedad.estado			= '4' AND 0 =1 )
			||	( propiedad.estado			= 'C' AND 0 =1 )
		--	|| 	( propiedad.estado			= 'P' AND  1=2  )	-- Prospeccion
			||	( propiedad.estado			= 'P' AND 0 =1 )
			||	( propiedad.estado			= 'B' AND 0 =1 )
			)
		
	
		
		AND   -- propiedades no publicadas
			(
				 propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
			)
	  	
				AND (
							( propiedad.tipo_operacion	= '' )															-- El tipo_operacion de la propiedad coincide con el indicado por el usuario
						||	( propiedad.tipo_operacion	IN ('V','A')  && '' = 'X' )										-- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
						||	( propiedad.tipo_operacion	= 'X'  && ('' = 'V' || '' = 'A') )	-- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
						||	( ''	= '' )								-- El usuario no ha seleccionado tipo_operacion, mostramos todo
						-- [20180806d]
						||	( propiedad.tipo_operacion	IN ('H')  && '' = 'C' )											-- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
					 )
				AND (
						  cod_valoracion = ''
						||
						  '' = ''
					 )

				-- cond_pais
				

				-- cond_zonas
				 AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61   ,99) ) 

				-- 20180806d
				
				
					-- cond_metazonas_portales
					
					-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
				
					
				
				
				AND (
					 	( propiedad.metatipo_propiedad	= '' )	-- el metatipo_propiedad es el seleccionado
					 	||
					 	( '' = '' )
					 )
				AND (
					 	( propiedad.tipo_propiedad	IN (0) )	-- el tipo de propiedad es el seleccionado
					 	||
					 	( ( '0' = '' || '0' = 0 ) )   -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad 			  && tipo_propiedad < 200 )	-- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
					 	||
					 	( ( '0' = '' || '0' = 0 ) && '' = 3 )	-- inversiones
					 )

			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			AND ( propiedad.superficie			>= ''			|| '' = '' )
			AND ( propiedad.superficie			<= ''			|| '' = '' )
			AND ( propiedad.superficie_util		>= ''		|| '' = '' )
			AND ( propiedad.superficie_util		<= ''		|| '' = '' )
			AND ( propiedad.superficie_parcela	>= ''	|| '' = '' )
			AND ( propiedad.superficie_parcela	<= ''	|| '' = '' )
			AND propiedad.fecha_alta			<= '20240517'
			
						AND
							(	-- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
								--	propiedad.tipo_operacion IN ('V','A','X')
								 	( propiedad.precio_pvp		<= ''	|| propiedad.precio_pvp	  IS NULL			|| '' = '' 	|| '' = '0' )
								&&	( propiedad.precio_pvp		>= ''	|| propiedad.precio_pvp	  IS NULL			|| '' = '' 	|| '' = '0' )

								&&	( propiedad.precio_alquiler	<= ''	|| propiedad.precio_alquiler IS NULL			|| '' = ''	|| '' = '0' )
								&&	( propiedad.precio_alquiler	>= ''	|| propiedad.precio_alquiler IS NULL			|| '' = ''	|| '' = '0' )
						)
							
		
		-- 20131223 rbz
		
		-- 20130128 rbz
		
		
		-- 20130916 rbz [20130131a]
		
		-- 20130506 rbz
		
		
		-- [20160430a]
		
		
		
		-- 20131028 rbz [20131028a]
		
		
		
		
		-- 20131220 rbz [20131220a]
		
		
		-- 20130514 rbz [20130514a]
		
		-- 20180305b
		
		-- [3370-4320]
		
		
	
 AND propiedad.num_fotos >= 1
 AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas

	  	

	ORDER BY 
				CASE
					WHEN web = 100 AND cod_empresa = 0 THEN 1	-- propiedades de la propia empresa-
					ELSE 9
				END,
				
			CASE
				WHEN web = 100 AND cod_empresa = 0 THEN prioridad 	-- propiedades de la propia empresa
				-- ELSE 999  -- no deberia ser -1?
				ELSE -1
			END DESC
			,     -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
				   -- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
				 cod_propiedad DESC -- 11 
	
 LIMIT 24 -- 24 = 24 -  % 
 -- num_prop_slide= grupo_registros=2 num_max_propiedades_x_pagina=24
 OFFSET 48 -- 3 offp

num_tuplas= 
24

Benahavís, Málaga

Cluster house for sale
Print sign
3.900.000€
Beautiful turnkey villa project in Montemayor. Construction ready to start with approved licence. The project was designed for a 5 bedroom-7 bathroom villa over 3 levels.

Reference:
493734 - MFSV1769
Size:
775m²
Plot size:
2.035m²
Bedrooms:
5
Bathrooms:
7
Garage:
Private
Swimming pool:
Private
Furnished kitchen:
Furnished with appliances
Orientation:
South
Air conditioning:
Cold
No. of floors:
3
Condition:
Excellent
Equipment:
Phone line, Water, Light, Intercom
Security measures:
Alarm

Details and photos

Marbella, Málaga

Cluster house for sale
Print sign
2.695.000€
This charming villa, just a few steps from the beach is located in the heart of one of the most sought-after urbanisations of Marbella's Golden Mile. In the past, The owners have enjoyed family life in this house all year round and therefore it was conditioned to prevent humidity and other issues. Despite its great condition, it represents an exciting opportunity for a renovation project. The basement holds great potential, offering opportunities for transformation into a game room, home cinema and more. There is room for a swimming pool in the garden.

Reference:
493733 - V-23257-D
Size:
310m²
Plot size:
434m²
Bedrooms:
4
Bathrooms:
3
Garage:
Private
Furnished kitchen:
Furnished with appliances
Terraces:
(40.00m²)
Orientation:
Southeast, South, Southwest
Heating:
Centralized
Air conditioning:
Cold
No. of floors:
3
Condition:
Good
Equipment:
Chimney
Security measures:
Alarm

Details and photos

Nueva andalucia, Málaga

House for sale
Print sign
1.175.000€
Casa Leo is an exquisite four bedroom property that sparkles with luxury, is sold fully furnished and is distributed over three levels. This townhouse has been completely renovated. It is located in Aloha Gardens, a beautiful gated development with lush gardens, three swimming pools and surrounded by trendy restaurants and cafes; it is at the foot of the golf valley, in the heart of Nueva Andalucía and just minutes away from Puerto Banús and Marbella. The ground floor consists of the living room, the open plan kitchen, furnished and equipped with Miele appliances. This space is connected to the terrace and garden with its barbecue area; a spacious and very luminous place thanks to its large windows. On the ground floor there is also a bedroom. On the first floor there are the rest of the bedrooms. The master bedroom has an en-suite bathroom and its own terrace. The top floor is to be enjoyed! A magnificent terrace, with swimming pool, sauna, bar and fire pit, this terrace is a marvel. The property has a garage parking space. There are so many details, luxuries, textures... You must see it for yourself. Call us now to visit.

Reference:
493732 - MFSTH1712
Size:
250m²
Plot size:
112m²
Bedrooms:
4
Bathrooms:
3
Furnished:
Fully furnished
Garage:
Private
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(112.00m²)
Orientation:
North
Air conditioning:
Cold
No. of floors:
3
Condition:
Excellent
Equipment:
Phone line, Water, Light

Details and photos

Ojén, Málaga

Apartment for sale
Print sign
339.000€
!Reduced for quick sale!!!!Stunning Ground Floor Apartment with Private Garden and Pool Access!! Welcome to your dream home! This beautiful ground floor apartment offers a harmonious blend of comfort, elegance, and convenience. Here's why you'll fall in love with it: Spacious and Bright: As you step inside, you'll be greeted by an unusually large lounge-dining area that bathes in natural light. The open layout creates a sense of freedom and relaxation. Modern Kitchen: The fully fitted modern kitchen is a culinary haven. Imagine preparing meals surrounded by sleek appliances and ample counter space. Plus, there's a separate utility-laundry room for added convenience. Two Luxurious Bedrooms: Both double bedrooms come with fitted wardrobes, ensuring plenty of storage space. Wake up to serene garden views and enjoy the tranquility of your private oasis. Sea Views from Your Terrace: Step out onto your covered terrace, where the sparkling Mediterranean Sea unfolds before you. Sip your morning coffee or host intimate gatherings in this exclusive outdoor space. Impeccably Maintained Gardens: The community's lush gardens are meticulously cared for by a dedicated gardener. Stroll through fragrant blooms and follow the path directly to the inviting pool—a refreshing escape on warm days. Fully Furnished: Move right in! This apartment comes fully furnished, allowing you to start enjoying the coastal lifestyle immediately. Private Carparking Space: No more parking woes! Your designated spot awaits, accessible via a secure gate entrance. La Mairena: A Hidden Gem: Nestled just outside Marbella, La Mairena offers the best of both worlds. Explore charming shops, dine at exquisite restaurants, and discover an internationally renowned school. Golf enthusiasts will appreciate the nearby golf course and other sports facilities. Short Drive to the Coast: Within minutes, you can have your toes in the sand, breathing in the salty ocean breeze. The coast beckons, and it's all conveniently close. Don't miss out on this exceptional opportunity. Contact us today to schedule a viewing and make this apartment your own!!

Reference:
493731
Size:
107m²
Bedrooms:
2
Bathrooms:
2
Furnished:
Fully furnished
Swimming pool:
Comunitary
Garden:
Comunitary
Floor:
Street level
Furnished kitchen:
Furnished with appliances
Orientation:
Southeast
Air conditioning:
Cold
No. of floors:
1
Condition:
Excellent
Equipment:
Water, Light, Intercom

Details and photos

Guadalmina, Málaga

Cluster house for sale
Print sign
7.450.000€
Detached Villa, Guadalmina Baja, Costa del Sol. 6 Bedrooms, 8.5 Bathrooms, Built 779 m², Terrace 284 m², Garden/Plot 1986 m². Setting : Beachside, Close To Sea, Close To Schools. Orientation : South. Condition : New Construction. Pool : Private. Climate Control : Air Conditioning, Hot A/C, Cold A/C, U/F Heating, U/F/H Bathrooms. Views : Sea, Garden. Features : Covered Terrace, Lift, Fitted Wardrobes, Private Terrace, Solarium, ADSL / WIFI, Sauna, Utility Room, Ensuite Bathroom, Marble Flooring, Double Glazing, Staff Accommodation, Fiber Optic. Furniture : Part Furnished. Kitchen : Fully Fitted. Garden : Private. Security : Electric Blinds, Entry Phone, Alarm System, Safe. Parking : Street, More Than One, Private. Utilities : Electricity, Drinkable Water, Telephone. Category : Holiday Homes, Luxury, Resale.

Reference:
493730
Size:
779m²
Plot size:
1.986m²
Bedrooms:
6
Bathrooms:
9
Furnished:
Partially furnished
Swimming pool:
Private
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(284.00m²)
Orientation:
South
Air conditioning:
Cold
No. of floors:
2
Condition:
New build
Equipment:
Phone line, Safe box, Water, Light, Floor heating (total), Intercom
Security measures:
Alarm

Details and photos

Centro, Valdepeñas, Ciudad Real

House for sale
JUST IN!
Print sign
50.000€


Reference:
493729
Size:
231m²
Plot size:
146m²
Bedrooms:
3
Bathrooms:
1
Furnished:
Not furnished
Garage:
Private (1 Parking places)
Garage type:
Closed
Independent dining room:
Yes
Furnished kitchen:
Not
Kitchen type:
Independent
WCs:
1
Terraces:
1
Courtyards:
2
Location:
Exterior
Orientation:
South
Location:
City center
Views:
Street
Type of ceiling:
Plaster
Finishing carpentry :
Sapeli
Floors:
Stoneware
Type of windows:
Aluminum
Type of glazing:
Double window
Storage room:
Yes
Basement:
No
Hot water:
Individual
Type hot water:
Diesel
Heating:
Individual
Heating type:
Diesel fuel
Air conditioning:
Cold-heat
Condition:
Needs some renovation
Availability:
Unoccupied
Equipment:
Antenna, Phone line, , Water, Light, Bathtub

Details and photos

Centro, Santa Cruz de Tenerife, Santa Cruz de Tenerife, Tenerife

Flat for sale
JUST IN!
Print sign
355.000€
Calle Febles Campos, 2


Reference:
493726 - FBLS TFVV
Size:
117m²
Usable size:
115m²
Bedrooms:
3
Bathrooms:
2
Furnished:
Not furnished
Garage:
No
Floor:
3rd
Built-in cupboards:
Yes
Independent dining room:
Yes
Furnished kitchen:
Furnished with appliances
Kitchen type:
Independent
Balconies:
1
Storage room:
Yes
Hot water:
Individual
Type hot water:
Electric heater
Air conditioning:
Cold-heat
Lift:
Yes
Building year:
1984 (40 year/s)
Equipment:
Refrigerator, Oven, Water, Appliances, Ceramic hob, Bathtub

Details and photos

La Cuesta, San Cristóbal de la Laguna, Santa Cruz de Tenerife, Tenerife

Flat for sale
JUST IN!
Print sign
163.706€
Calle El molino, 9
Investment opportunity! Apartment on the second floor with elevator, 2 bedrooms, a separate kitchen and is partially furnished. A beautiful wooden platform has recently been installed, which gives it a touch of elegance and warmth. Strategically located in La Cuesta, this property is close to the tram stop, making your travels easier. In addition, you will have at your disposal services such as Mercadona and other shops just a few steps away. And that's not all! The price includes a parking space, a real advantage in a building without parking spaces. Don't miss this opportunity to make it your home. Call now for more information!

Reference:
493723 - MOL TFVV
Size:
69m²
Usable size:
68m²
Bedrooms:
2
Bathrooms:
1
Furnished:
Partially furnished
Built-in cupboards:
Yes
Furnished kitchen:
Furnished with appliances
Kitchen type:
Independent
Storage room:
Yes
Hot water:
Individual
Type hot water:
Electric heater
Equipment:
TV, Refrigerator, Washing machine, Oven, Appliances, Ceramic hob, Bathtub

Details and photos

Fuensantilla - Edisol, Levante, Córdoba

Flat for sale
RefKROC-493721 🔗
PUBLISH ONLY PORTALS
Print sign
75.000€

Apartment in Levante - Edisol, renovated and ready for you

Are you looking for your home to move into? Do you want to invest in a property where you don't have to do anything? You're in luck, look no further we have it for you. It is in Levante in the Edisol neighborhood, a consolidated area with all kinds of services at hand such as supermarkets, schools, close to the city center and with easy access to the highway. When you enter you will feel that you have arrived at home, the home you always wanted. With wooden floors and windows that offer you an unmatched feeling. For hot days, you have air conditioning throughout the apartment which consists of two bedrooms, living room and kitchen. Also some little secrets that you will have to discover if you visit with us. And if you need it, we offer you customized financing with the best conditions. Don't miss the opportunity to live in this cozy renovated apartment in the Levante - Lepanto - Edisol area! To comply with current regulations, we have the D.I.A. Abbreviated Information Document available to the client. At your disposal if you need it. The prices indicated do not expire but may be subject to change without prior notice. PURCHASE EXPENSES will be according to law (Notary, Registry and taxes) and are not included in the indicated price. Agency Fees are NOT included. Unless the offer specifies it, the price of the property does not include the content: furniture, appliances, clothing, tools, vehicles or any article or decorative element that may appear in the images. This announcement is not binding and may contain errors.

Reference:
493721
Size:
58m²
Bedrooms:
2
Bathrooms:
1
Furnished:
Fully furnished
Floor:
3rd
Lounges:
1
Built-in cupboards:
Yes
Independent dining room:
Yes
Furnished kitchen:
Furnished with appliances
Kitchen type:
Independent
Terraces:
1 (2.00m²)
Ceiling height:
Regular
Walls:
Flat
Storage room:
Yes
Hot water:
Individual
Type hot water:
Electric heater
Air conditioning:
Splits and units
Lift:
No
Condition:
Renovated/modernised
Availability:
Unoccupied
Equipment:
, Shower plate, Rooftop
Handicapped access:
No

Sur, Aguadulce, Almería

Flat for rent
GOOD DEAL
Print sign
700€ (£ 614 app.)
SE ALQUILA Good flat in Aguadulce Very bright, consists of two dormitories with built-in wardrobes, large living room with access to the terrace, a complete bathroom. Lavadero. Cooking amueblada. Swimming pool, garage. Amueblado, Children's Park. Ideal for holidays in Verano and available from SEPTEMBER TO JUNE.

Reference:
493716
Size:
85m²
Usable size:
70m²
Bedrooms:
2
Bathrooms:
1
Furnished:
Fully furnished
Garage:
Comunitary
Garage type:
Carport
Swimming pool:
Comunitary
Floor:
1st
Built-in cupboards:
Yes
Independent dining room:
Yes
Furnished kitchen:
Furnished with appliances
Kitchen type:
Independent
Orientation:
Southeast, South, Southwest
Location:
Beachfront
Walls:
Flat
Floors:
Porcelain stoneware
Storage room:
No
Lift:
Yes
Urbanization:
Private
Building year:
2010 (14 year/s)
Condition:
Good
Equipment:
Refrigerator, Washing machine, Video intercom, Ceramic hob
Sport facilities:
Paddel
Security measures:
Alarm, Security door, Video-surveillance, Grille
Doorman:
No
Rental bond:
700€
Comunity fee:
70€ (community fee included)

Details and photos

Mijas, Málaga

House for sale
JUST IN!
Print sign
368.000€
Fabulous semi-detached house in an urbanization of Las Lagunas de Mijas almost in the El Hornillo area. It is a three-story semi-detached house plus a large solarium with fabulous views of the sea and the surrounding area. It consists of 4 bedrooms, 2 bathrooms + 1 toilet, independent equipped kitchen, three terraces, private garden and own parking area at the entrance. The semi-detached house is in good condition and is delivered furnished with very good quality furniture, ready to move into. The living area is about 180 m2 built, to which must be added the solarium, the terraces, the garden and the private parking area. It is located in a quiet area within an urbanization with a pool and garden.

Reference:
493395 - PA-4004
Size:
180m²
Bedrooms:
4
Bathrooms:
2
Furnished:
Fully furnished
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(78.00m²)
Orientation:
South
Air conditioning:
Cold
No. of floors:
4
Condition:
Good

Details and photos

Torremolinos, Málaga

Apartment for sale
JUST IN!
Print sign
239.000€
2 bedroom apartment with sea views in El Pinillo - Torremolinos Charming home located in the Pinillo area, with a privileged corner position. Terrace with exceptional luminosity throughout the day. This home has an American kitchen open to the living room, two terraces, two bedrooms (one with a built-in wardrobe) and a bathroom. The living room has reversible hot/cold air conditioning. This property has community pools, tennis court, barbecue area, summer bar and large garden areas. Community €140 per month (water included), ibi €200 Beach/Sea: 4min by car Malaga Airport: 15min by car Direct access to the highway, shopping center and all kinds of services: bus, schools, institutes, supermarkets, pharmacies, bars, restaurants.

Reference:
493394
Size:
83m²
Bedrooms:
2
Bathrooms:
1
Furnished:
Partially furnished
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Air conditioning:
Cold
No. of floors:
1
Condition:
Renovated/modernised

Details and photos

Fuengirola, Málaga

Apartment for sale
JUST IN!
Print sign
550.000€
Opportunity, brand new renovated!! top floor facing the sea. stunning beach views. 15m2 L-shaped terrace, two-bedroom house with built-in wardrobes and two bathrooms, one of them en suite. Community area with large swimming pools and green areas. Storage parking included. elevator, air conditioning, brand new renovated, sea views, community €120-month

Reference:
493393
Size:
86m²
Bedrooms:
2
Bathrooms:
2
Swimming pool:
Comunitary
Garden:
Comunitary
Terraces:
(12.00m²)
Orientation:
Southeast
Air conditioning:
Cold
No. of floors:
12
Condition:
Excellent
Equipment:
Water, Intercom

Details and photos

Los Pacos, Fuengirola, Málaga

Apartment for sale
JUST IN!
Print sign
249.500€
Middle Floor Apartment, Los Pacos, Costa del Sol. 2 Bedrooms, 2 Bathrooms, Built 70 m², Terrace 6 m². Setting : Suburban, Close To Town, Urbanisation. Orientation : South. Condition : Excellent. Pool : Communal. Climate Control : Air Conditioning, U/F/H Bathrooms. Features : Lift, Fitted Wardrobes, Near Transport, Private Terrace, Utility Room, Ensuite Bathroom, Double Glazing. Furniture : Part Furnished. Kitchen : Fully Fitted. Garden : Communal. Security : Gated Complex, Entry Phone. Parking : Underground. Utilities : Electricity. Category : Holiday Homes, Resale.

Reference:
493392
Size:
77m²
Bedrooms:
2
Bathrooms:
2
Furnished:
Partially furnished
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(6.00m²)
Orientation:
South
Air conditioning:
Cold
No. of floors:
1
Condition:
Excellent
Equipment:
Light, Intercom

Details and photos

Nueva andalucia, Málaga

Apartment for sale
JUST IN!
Print sign
450.000€
Exciting Opportunity a very competitively priced spacious 2-Bedroom apartment in Aloha, Nueva Andalucia! Discover a bright, quality apartment nestled in a premier gated community. Step into an inviting entrance hallway with guest toilet leading to a generously sized lounge dining room, offering direct access to a charming terrace with views of lush communal gardens and pool. Enjoy seamless flow to a fully fitted kitchen from both dining area and hallway. Two bedrooms and two fully fitted bathrooms with underfloor heating for added comfort. Experience 5-star amenities including gym, sauna, steam room, and indoor pool. Ideal for both personal retreat and rental investment, with tourist license in place. Mortgage options available from a top Spanish bank. Plus, benefit from three parking spaces and a spacious storage room included with the property. Don't miss out on this exceptional opportunity!

Reference:
493391
Size:
144m²
Bedrooms:
2
Bathrooms:
3
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(30.00m²)
Orientation:
South
Air conditioning:
Cold
No. of floors:
1
Condition:
Excellent
Equipment:
Phone line, Safe box, Water, Light, Gas, Intercom

Details and photos

Mijas, Málaga

Cluster house for sale
JUST IN!
Print sign
995.000€
Discover the epitome of luxury living in this stunning villa nestled in a prestigious urbanizacion. Boasting a total of five bedrooms and three bathrooms, this property offers a spacious and comfortable retreat for your family and guests. The main house features three inviting bedrooms, complemented by two elegant bathrooms. Step into the heart of the home, where an open-concept living, dining, and kitchen area awaits. Natural light floods the space, highlighting the modern design and premium finishes. Imagine entertaining friends and family in this stylish setting, with seamless transitions from indoors to the captivating terrace. The terrace itself is a masterpiece, providing breathtaking sea views that stretch as far as the eye can see. Whether you're enjoying a morning coffee or hosting an evening soiree, this outdoor space is destined to become your favorite spot. Take a refreshing dip in the inviting pool or simply unwind in the tranquility of the surroundings. For additional comfort and privacy, the property includes a guest house with two bedrooms and a well-appointed bathroom. Perfect for accommodating visitors or creating a dedicated space for work or hobbies. Convenience meets luxury with the inclusion of a garage, ensuring secure parking for your vehicle. The mature garden adds a touch of nature to the property, creating a serene atmosphere that enhances the overall charm. Seize the opportunity to own this exceptional villa in Urbanizacion Peña Blanquilla – where every detail is crafted for a lifestyle of elegance and relaxation. Contact us now to make this dream property your reality. Detached Villa, Mijas, Costa del Sol. 4 Bedrooms, 2 Bathrooms, Built 185 m², Terrace 65 m². Setting : Town, Country, Close To Golf, Close To Shops, Close To Town, Close To Forest, Urbanisation. Orientation : South East, South, South West. Condition : Excellent. Pool : Private. Climate Control : Air Conditioning. Views : Sea, Mountain, Port, Country, Panoramic, Pool, Courtyard. Features : Covered Terrace, Near Transport. Furniture : Part Furnished. Kitchen : Fully Fitted. Garden : Private. Parking : Garage.

Reference:
493390
Size:
317m²
Plot size:
1.026m²
Bedrooms:
5
Bathrooms:
3
Garage:
Private
Swimming pool:
Private
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(65.00m²)
Orientation:
Southeast, South, Southwest
Air conditioning:
Cold
No. of floors:
2
Condition:
Excellent

Details and photos

Cajiz, Málaga

Ranch for sale
JUST IN!
Print sign
880.000€
For sale east of Malaga, a unique and charming estate with nearly 30,000 square meters of land awaits its new owner. This exceptional & stunning property exudes a castle-like allure and is situated in a peaceful, secluded area in Cajiz, just 26 kilometers east of Malaga. Upon entering the property through an automated gate, a short private drive leads you to the expansive driveway, offering ample parking options including two carports and a spacious garage. The outdoor space is a sight to behold, featuring olive trees that can yield 1000 liters of oil per year,if someone is up for the task, as well as many various fruit trees. Nestled below the finca, the swimming pool provides a private retreat, while two very cozy cottages accommodate guests. The finca itself boasts numerous charming and clever elements, such as a cozy lounge, the amazing mountain views, a wine cellar, and a luxurious ensuite bedroom with Andalusian and Moroccan influences. The grand entrance hall sets the tone for the property, leading to a remarkable stone pathway that unveils a private wine cellar that can easily be converted into an additional bedroom, as this property have another wine cellar around the pool area. A spiral staircase ascends to the main bedroom with a balcony offering serene bird-filled mood and a charming bathroom featuring a Moroccan-style bathtub. The spacious living room opens up to a delightful patio overlooking the picturesque mountains, while a few steps lead to a second bedroom with lovely ceiling beams and an adjacent bathroom. Descending a few steps from the hall, you'll find the open kitchen and dining area, exuding modern charm with a cozy fireplace and access to the outdoor terraces. Beyond the terraces lies the pool area, a workshop shed, two cottages, and an underground wine cellar crafted by the owner, complete with a well. This southfaced property, built in 1994, is filled with unique stories embodied in every nook and cranny. Surrounded by vast fields yet conveniently located just a short drive from the beach, shops, and restaurants, this finca offers a perfect blend of tranquility and accessibility. Offered at €880,000, this estate comprises three bedrooms (can easy be 4 or 5) , three bathrooms, 230 square meters of built area, 195 square meters of usable space, and a sprawling 29721 square meters of land with fruit trees. Additionally, it features three private water wells and boasts a prime location just one kilometer from the motorway and three kilometers from the beach. Property tax is 341 euros a year

Reference:
493389
Size:
230m²
Plot size:
29.721m²
Bedrooms:
3
Bathrooms:
3
Furnished:
Partially furnished
Garage:
Private
Swimming pool:
Private
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Orientation:
North, East, South, West
Air conditioning:
Cold
No. of floors:
2
Condition:
Excellent
Equipment:
Light, Chimney

Details and photos

Benahavís, Málaga

Apartment for sale
JUST IN!
Print sign
415.000€
Independent 3-bedroom apartment with a large patio. This home consists of a large living area with a fireplace, the fully fitted kitchen sits next to the living room and has the chance to be converted into an open plan. Then three comfortable bedrooms, the master with an en-suite bathroom and nice views toward the mountains of Benahavís and the football field. One level below there is a large patio with a covered terrace and a second dining area where you can enjoy family reunions and events.

Reference:
493388
Size:
132m²
Bedrooms:
3
Bathrooms:
2
Garden:
Comunitary
Floor:
Street level
Furnished kitchen:
Furnished with appliances
Terraces:
(200.00m²)
Orientation:
East
No. of floors:
2
Condition:
Good
Equipment:
Water, Light, Chimney

Details and photos

Calahonda, Mijas, Málaga

House for sale
JUST IN!
Print sign
369.000€
This lovely 3 bedroom townhouse is located in lower Calahonda with everything on your door step. On the front of the house is a private car parking. There is a small terrace. Walking in we have a guest toilet, a good size enclosed kitchen and a living room with fire place. It leads out on to a large, with glass curtains, enclosed terrace. On the first floor are three bedrooms with two bathroom of which one en-suite. The urbanization is gated and has a good size pool and lovely gardens. The bars, restaurants, supermarkets and stores are within a couple of minutes walk. The beach you reach within a 5 minute walk. Great location!

Reference:
493387 - 5372-TH
Size:
116m²
Bedrooms:
3
Bathrooms:
3
Furnished:
Partially furnished
Swimming pool:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(40.00m²)
Orientation:
East, West
Air conditioning:
Cold
No. of floors:
2
Condition:
Good
Equipment:
Chimney

Details and photos

Puerto Banús, Marbella, Málaga

House for sale
JUST IN!
Print sign
1.995.000€
Beachfront complex, Estepona, New Golden Mile. Fully renovated double semidetached townhouse located in a front line beach complex that resembles a fishing village, full of character and tradition! The location is fantastic, 60 meters from the promenade & the Mediterranean sea and only 5 minutes away from Estepona center and 10 minutes away from Puerto Banus. Set in a peaceful environment where you can hear the waves of the sea. There is a fabulous beach restaurant 50 meters away. The property was completely renovated in 2022, Spanish/Scandinavian Style. The terraces have been very well insulated and new double glazed windows have been installed. The house comprises a total of 5 bedrooms, 5 bathrooms (2 bedroom and 2 bathroom on the ground level!), a large fully fitted kitchen, a nice living room and a beautiful patio for entertaining. Storage rooms. On the first floor you will find 3 double bedrooms with en-suite bathrooms, and a superb roof top terrace with loads of privacy and panoramic views to the sea. Viewing are highly recommended. The terrace also contains a nice small pool for a relaxing dip. Fabulous sea views from the upstairs terraces. A newly built promenade and a bus stop only a walk away so a car is not always necessary.

Reference:
493386 - SH
Size:
220m²
Bedrooms:
5
Bathrooms:
5
Furnished:
Fully furnished
Swimming pool:
Private
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(100.00m²)
Orientation:
Southeast, South
Air conditioning:
Pre
No. of floors:
2
Condition:
Excellent
Security measures:
Alarm

Details and photos

Alhaurín de la Torre, Málaga

House for sale
JUST IN!
Print sign
440.000€
A semi-detached villa has 4 bedromms with a unique layout spread across three floors is available for sale. Features include a spacious living room, garden, kitchen, three bedrooms, two full bathrooms, a garage, office space, communal garden areas, and a swimming pool. Ideal for comfort and practicality, equipped with built-in closets and a storage room. Contact for more details and viewing. This charming semi-detached villa is a hidden gem waiting to be discovered. As you step inside, you are greeted by a spacious living room that offers the perfect setting for relaxation and entertainment. The kitchen is a chef's dream, with modern appliances and ample counter space for culinary creations. Venturing upstairs, you will find three cozy bedrooms, each offering a tranquil retreat at the end of a long day. The villa also boasts a garage, ideal for keeping your vehicles secure, as well as office space for those who work from home or need a quiet area for creativity. The communal garden areas are perfect for enjoying the outdoors, while the swimming pool offers a refreshing escape on warm days. With built-in closets and a storage room, this villa seamlessly combines comfort and practicality. Whether you are looking for a peaceful sanctuary or a place to entertain friends and family, this property has it all. Don't miss the opportunity to make this unique villa your own - contact us today for more details and to schedule a viewing.

Reference:
493385 - villaAlhaurin
Size:
244m²
Bedrooms:
4
Bathrooms:
3
Furnished:
Fully furnished
Garage:
Private
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Terraces:
(100.00m²)
Orientation:
South, Southwest
Air conditioning:
Cold
No. of floors:
2
Condition:
Good
Equipment:
Phone line, Water, Light, Gas

Details and photos

Benahavís, Málaga

Cluster house for sale
JUST IN!
Print sign
3.390.000€
This sophisticated 4-bedroom villa is now available for purchase within the exclusive confines of the Marbella Club Golf Resort, nestled amidst the picturesque hills of Benahavis. Surrounded by lush natural landscapes and upscale properties, this gated golf resort offers an unparalleled living experience. As an extension of the iconic Marbella Club Hotel, it exudes elegance, style, and pedigree. The resort features an 18-hole golf course designed by the legendary Dave Thomas, offering spectacular vistas of the Mediterranean Sea, Gibraltar, and the African coastline. Additionally, the resort boasts a Golf School, an exclusive Clubhouse, café and restaurant facilities, and a superb Equestrian center catering to major national and international events, along with extensive trekking areas. The location is both enchanting and privileged, nestled in the lap of nature yet conveniently close to all amenities. Just a 20-minute drive from the Marbella Club Hotel and Puente Romano, as well as the luxurious amenities of Marbella&#039;s Golden Mile, it also offers easy access to sandy beaches, other golf courses, the vibrant Puerto Banus, San Pedro, Marbella, Estepona, and the gourmet village of Benahavis. Set upon an expansive plot of 5,388 m², this contemporary-style villa offers 352 m² of built-up area and a 185 m² terrace space. It&#039;s a feast for the senses, boasting modern chic design and breathtaking vistas of the sea, majestic mountains, and verdant golf course. Upon entering the property, you&#039;ll be immediately captivated by the panoramic views that envelop you. The magnificent interior features 3 bedrooms, each meticulously designed for both aesthetics and functionality. Three modern bathrooms (all en-suite) are adorned with mirrors, luxurious fixtures, wooden cabinets, and vanity units, creating an immaculate and rejuvenating ambiance. A cozy living room with a fireplace and abundant natural light provides a welcoming space for relaxation and socializing. Expansive sliding glass doors lead to a generous chill-out terrace with transparent balustrades, offering stunning views. The fully equipped minimalist-style kitchen boasts sleek design, an island, and top-of-the-line appliances, ideal for culinary enthusiasts and entertaining. Designed with convenience in mind, the villa includes a private garage with 2 parking spaces, walk-in and fitted wardrobes, and a storage room, ensuring ample space for personal belongings. Outside, the landscaped gardens and impressive infinity saltwater swimming pool with sunbathing areas create an inviting outdoor oasis. A solarium beckons to bask in the warm sun while enjoying the captivating views. Crafted for luxurious living and entertaining, this eco-friendly property is offered in excellent condition and tailored to the sophisticated Marbella lifestyle. It boasts luxury freestanding bathtubs, a floating staircase, LED lighting, double-glazing, air conditioning, and underfloor heating throughout the home.

Reference:
493384 - 395-AP2328
Size:
352m²
Plot size:
5.388m²
Bedrooms:
4
Bathrooms:
5
Garage:
Private
Swimming pool:
Private
Garden:
Comunitary
Terraces:
(185.00m²)
No. of floors:
1
Condition:
Excellent
Equipment:
Chimney

Details and photos

Arenas, Málaga

Cluster house for sale
JUST IN!
Print sign
465.000€
Nestled in the serene beauty of Arenas, this captivating villa offers an unparalleled living experience. Boasting panoramic vistas of both the sea and mountains, this residence is a sanctuary of luxury and tranquility. This elegant villa spans 276m2, set on a spacious plot of 5502m2, all on one floor for seamless accessibility. Inside, three beautifully designed bedrooms provide ultimate comfort, complemented by two bathrooms, including a luxurious en-suite in the master bedroom. Constructed in 2004, the villa ensures modern amenities and quality craftsmanship. Relax and unwind in the inviting 5 x 10 metre pool, perfect for leisurely days, or immerse yourself in the grandeur of the living room with 5-meter tall ceilings, creating a sense of spaciousness and opulence. This villa also features underfloor heating, providing cozy warmth and comfort throughout all the rooms. Additional amenities include two charming wooden houses, one serving as a fully-equipped kitchen/laundry room, and the other as an extra bedroom, providing flexibility and convenience. Conveniently located just a 5-minute drive from the charming town of Arenas, the villa offers access to local amenities and services. Enjoy easy access to pristine beaches, with a short 15-20 minute drive bringing you to the captivating shores of the coast. Revel in the tranquility of the countryside while still being within reach of urban conveniences. This exceptional villa is an embodiment of luxury living, offering a harmonious blend of elegance, comfort, and natural beauty. Whether you seek a serene retreat or a stylish residence to entertain guests, this property fulfills every desire. Don&#039;t miss the opportunity to make this extraordinary villa your own! Contact us today to arrange a viewing and embark on the journey to owning your dream home in Arenas. We are pleased to be able to present this dream property to you soon, either personally or via virtual viewing. Because this world is unique - just like our Axarquía. In Andalusia. On the Costa del Sol. Here, on the sunny side of life...

Reference:
493383 - 6001
Size:
276m²
Plot size:
5.502m²
Bedrooms:
3
Bathrooms:
2
Swimming pool:
Private
Garden:
Comunitary
Orientation:
Southwest
Air conditioning:
Cold
No. of floors:
1

Details and photos

Marbella, Málaga

Apartment for sale
JUST IN!
Print sign
1.290.000€
Refurbished property of the highest quality, situated in the exclusive complex, LAS BRISAS COUNTRY CLUB. This property is located in a complex of 18 neighbours, with a communal garden area so extensive, that it gives a unique privacy to the EXCLUSIVE neighbours who reside in this complex with its wonderful swimming pool. The property is located on an attic floor, and the moment you enter the property you will notice the beautiful details, and the unique and exclusive quality with which it has been refurbished. It has home automation and aerothermics. On the main floor there is a guest toilet, three large bedrooms with double wardrobes and en-suite bathrooms (one of them has a terrace with fabulous golf views), a laundry area, a beautiful open plan kitchen with top of the range appliances, a beautiful living room with fireplace and a terrace with wonderful views. On the second floor we find a large room that can be used for guests, or as a second living room. To all this we must add that the property has three underground parking spaces, and an important detail is that the lift is sized for two people. The property has centralised hot and cold air conditioning.

Reference:
493382
Size:
200m²
Bedrooms:
3
Bathrooms:
3
Furnished:
Fully furnished
Swimming pool:
Comunitary
Garden:
Comunitary
Furnished kitchen:
Furnished with appliances
Orientation:
Southeast, Southwest
Air conditioning:
Cold-heat
No. of floors:
2
Condition:
Renovated/modernised
Equipment:
Phone line, Water, Light

Details and photos

New properties

Would you like to receive by email the properties we include in the website?






Selected: 13430 properties« backnext »



Cannot find the property you are looking for? We have more Property search, please send us an email and let us know us what kind of properties you are interested on. You may also subscribe to our newsletter to receive information of new properties for sale in España.

Privacy policy